﻿CREATE TABLE [org].[Business] (
    [BusinessId]                      INT             NOT NULL,
    [BusinessCode]                    CHAR (5)        NOT NULL,
    [BusinessName]                    VARCHAR (50)    NOT NULL,
    [BusinessDescription]             NVARCHAR (1000) NULL,
    [BusinessFlashPnlMinThresholdGBP] DECIMAL (18, 2) NULL,
    [BusinessFlashPnLMaxThresholdGBP] DECIMAL (18, 2) NULL,
    [BusinessFlashManualUpload]       BIT             NOT NULL,
    [BusinessFlashMurexUpload]        BIT             NOT NULL,
    [BusinessStartDate]               DATE            NOT NULL,
    [BusinessEndDate]                 DATE            NULL,
    [IsLatest]                        BIT             NOT NULL,
    [IsActive]                        BIT             NOT NULL,
    [IsInternal]                      BIT             NOT NULL,
    PRIMARY KEY CLUSTERED ([BusinessId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

